2014-06-23 - 13329.100 - Spec - ATP FM #ABAP #InventoryManagement

SPECIFICATIONS

13329.100 - ATP FM

Requirement Summary

---

Need to create an extractor using the the new function module for ATP to get the new materials ATP stock for chase.

Admin Info

---

Purpose	Need to create an extractor using the the new FM for ATP to get the new material ATP stock for chase.
Requested By	Mark Harris
Spec Created By	Chandramouli K
Spec Created Date	06/23/2014
Spec QA by	Uday Kumar P
Objects	ZDS_BI_ATPEXTRACT_CHASE,ZBI_GENERIC_ATPEXTRACT_NEW & ZDSOINVD.
Document Status	Complete

References

---

Prior Tickets

13329.200

Documents

None

Functional Requirement

---

ECC

Need to create a new function module based on the logic given below:
1. Pick Material, Season, Collection & Size from J_3AMSEA table where season is between 700 and 899.
2. Only select those materials from J_3AMSEA in step 1 which are not present in MCHB table.
3. Find Plant for those materials from MARC table.
4. Find Sales organization from T001W table for that Plant.
5. Consider only those records for which system date in between order date window(order to & order from), Customer = blank and Ship from date is greater than system date(future date) in /AFS/DPRG_KOND table to find valid season for that material.
6. Now do the ATP check using condition Requested Delivery Date = Ship From Date using the tcode /N/AFS/ATPS.
7. Discard those records where ATP stock = 0.
8. Output fields from the FM are Material, Season, Collection, Size, Plant, Sales Org, Sales Document type(ZOR), Division(00) and Distribution channel(10).

BW

1. Need to create the Generic datasource based on the function module in ECC.
2. Need to replicate the datasource into BW.
3. Need to map this new datasource to the existing ATP DSO by creating the transformation and DTP.
4. Once the dataflow is tested successfully, need to include this into ATP process chain.

Solution Summary

---

ECC
1. Need to create the function module in NECNED as per the logic specifed above.
2. Need to create the transport request after successful unit testing.

BW
1. Need the create the Generic datasource based on the function module in NECNED.
2. Need to replicate the datasource into BPD.
3. Need to create dataflow for the datasource in BPD.
4. Need to add this dataflow to the existing Daily ATP Process chain in BPD.
5. Need to create the transport request and collect all objects into it.

Test Plan

SNo	Test Scenario	Expected Results
1	Check if the function module is working as per the logic defined.	Function module should work perfectly as per the logic defined.
2	Check whether all the changes are collected into the transport requests.	All the objects & changes must be collected into the transport request.

Solution Details

---

ECC
1. Need to create the function module ZBI_GENERIC_ATPEXTRACT_NEW in NECNED as per the logic defined. This new Function Module is a copy of the existing Function Module ZBI_GENERIC_ATPEXTRACT and the above logic is added to the FM to get the ATP Stock for new Materials which does not have batch data.
2. Need to unit test the FM with test materials created in NECNED.
3. Need to create the transport request after successful unit testing.

BW
1. Need the create the Generic datasource ZDS_BI_ATPEXTRACT_CHASE based on the function module ZBI_GENERIC_ATPEXTRACT_NEW in NECNED.
2. Need to replicate this datasource into BPD.
3. Need to create the dataflow for the datasource to the ATP DSO in BPD.
4. Need to add required dataflow objects to the existing Daily ATP Process chain ZPC_ATP_INV in BPD.
5. Need to collect all the objects and changes in to the transport request.

Issues

---

None